ABL / ABL GL / ABL GL Transactions

ABL GL Transactions

The ABL GL Transactions page shows a record of all GL transactions setup that has been made. In the Cync application, you can automatically post a GL transaction for every charge code setup. You may also export the list of ABL GL transactions in the QuickBooks and CSV formats.

Navigation: ABL → ABL GL → ABL GL Transactions

Refer to the Screenshot:
ABL GL Transactions Home Page

NoteWhen the Posting type is selected for any fee charge code in the Charges Templates page as Accrue to Loan or Accrue to Statement, instead of cumulative fees, each fee is posted individually end of the month in the ABL GL transactions page.
Custom interest or any interest charges that are added to accrued fees are also posted separately in GL instead of accrued interest records.

For example,
If the Posting Type is selected as Accrue to Statement for the three fee charge codes given below, ABL GL Transactions page posts each fee individually at the end of the month.

Serial No.

Name of the charge code

Fee

1.

Monthly Service Fee

$50 per month

2.

Facility Fee

$10 per month

3.

Admin Fee ($05 per day)

$150 per month 

 

Refer to the screenshot:
Transactions charged

Fields and Descriptions

Fields

Descriptions

Journal Number

Defines the transaction journal number.

Client

Defines the client name.

Transaction Date

Specifies the transaction posted date.

GL Amount Debit

Specifies the GL debited amount.

GL Amount Credit

Specifies the GL credited amount.

GL Account No

Defines the GL Account No for the posted transaction.

GL Account Name

Defines the name for the GL account transaction.

Insert Date

Specifies the ABL GL Transaction inserted date. 

Loan Type

Specifies the Loan type. 

Loan Id

Loan Id is updated based on the changes performed under the Basic Client details page.

NAICS Code

Specifies the NAICS code. 

Transaction Code

It defines the transaction code of the charge codes for which the transaction is processed.

Note This is a non-editable field.

Account Group

It displays the value provided by the user in the account group field in GL setup page.

Source Type

It displays the source type such as advance, collection, Fees / Charges, Interest of the charge code of which the transaction is processed.

Note This is a non-editable field.

Sales Region

Specifies the sales region for the respective client.

Note This is a non-editable field.

 

Each ABL GL Transaction is logged on the Audit Log page.

The ABL GL Transactions report can be extracted using the Export button.

The Export  button will be displayed for the user role based on the settings done under the Roles and PermissionsRoles and Permissions page. By default, the Export option would be enabled for the Administrator role.


To extract the ABL GL Transactions report using the Export button, perform these steps:

Click the Export button. A pop-up window appears. 

Refer to the screenshot:
Export popup

  1. In the Clients field, select the client name from the drop-down list.
  2. The clients' drop-down field lists only the applicable client for the logged-in user.
  3. In the Start Date field, select the start date to export the GL Transaction report.
  4. In the End Date field, select the end date to export the GL Transaction report.
  5. In the Date Range By field, select any of the following options:
    1. Transaction – If selected, the system exports the GL transaction data based on the transaction made within the selected date range.
    2. Insert – If selected, the system exports the GL transaction data based on the transaction inserted within the selected date range. 
  6. In the File Type field, perform the following actions: 
    1. Select any one of the following options:
      1. Quick Book - If selected, the ABL GL transaction report will be extracted. If the file format is based on the selected date range.
      2. CSV - If selected, the ABL GL transaction report will be extracted in .csv file format based on the selected date range.
    2. Select any one of the following options:
      1. Summary – If selected, the ABL GL transaction report will be extracted with Summary level data based on the selected options
      2. Details – If selected, the ABL GL transaction report will be extracted with detailed level data based on the selected options. 
  7. Click the Export button. The report has been extracted successfully.

Refer to the screenshot:
Excel Report ABL-GL Transactions

To extract the ABL GL Transaction report in an Excel format, perform these steps:

  1. Click the Export button. A pop-up window appears.

    Refer to the screenshot: Export data selection popup
  2. Click the Save button located at the top-right corner. The ABL GL transaction report has been extracted successfully in an Excel format.

    Refer to the screenshot: 
    Excel file example